﻿namespace ParsePtb.consts
{
    public class Constant
    {

        // 13个字段
        //关联表 公共字段
        public static string RELAT_COMM_COLUMNS = "ID,SUPPLIER_ID,PROJECT_NO,MARK_NO,PACK_NO,PACK_NAME,RELATE_ID,REMARK,CREATE_USER,CREATE_TIME,UPDATE_USER,UPDATE_TIME,TYPE";

        // OS_ZB_SUPPLIER_PARTS_INFO 字段  产品部件
        public static string PARTS_COLUMNS = "ID,SUPPLIER_ID,PRODUCT_PARTS_ID,PARTS,PRODUCT_BRAND,REMARK,CREATE_USER,CREATE_TIME,UPDATE_USER,UPDATE_TIME,AGENT,ATTACH_ID,MODEL,PROVINCE_APPLY_NO,MATERIAL_NO,PROJECT_NO,MARK_NO,PACK_NAME,PRODUCT_NAME";


        //OS_ZB_SUPPLIER_BID_ATTACHMENT 字段 标书上传
        public static string BID_ATTACH_COLUMNS = "ID,BID_ID,SUPPLIER_ID,PROJECT_NO,MARK_NO,PACK_NAME,PACK_NO,ATTACH_ID,IS_DELETE,REMARK,CREATE_USER,CREATE_TIME,UPDATE_USER,UPDATE_TIME,IS_DECRYPT,DECRYPT_TIME,DECRYPT_USER,DECRYPT_STATUS,SIGN_KEY,ATTACH_TYPE,FAIL_REASON,ARCHIVE_STATUS,ARCHIVE_KEY,ZIP_ATTACH_ID,ZIP_ARCHIVE_KEY";


        //供应商基础信息的字段
        public static string SUPPLIER_INFO_COLUMNS = "ID,ENT_NAME,ENT_INTRODUCE,ENT_REG_TIME,REG_CAPITAL,REG_PLACE,FAC_BUILD_PLACE,LEGAL_REP,ENT_TYPE,DEPT_TYPE,ENT_NATURE,BUSINESS_LIC_REG_NO,BUSINESS_LIC_ACTIVE_TYPE,BUSINESS_LIC_ACTIVE_TIME,BUSINESS_LIC_CHECK_TIME,INDUS_REG_NO,ORG_NO,NATIONAL_TAX_NO,POST_CODE,MAIL_ADDRESS,STATUS,BUSINESS_SCOPE,REG_TIME,LOGIN_ACCOUNT,LOGIN_PWD,AUDIT_REASION,AUDIT_TIME,AUDIT_USER_ID,REMARK, CREATE_USER, CREATE_TIME, UPDATE_USER, UPDATE_TIME, GSYYZZ_ATTACHID, ZZJGDM_ATTACHID, SWDJZM_ATTACHID, SZHYZZ_ATTACHID, THREE_CERT_ONENESS, ZZYJHSZM_ATTACHID, LOGIN_PHONE, SFCJZZYJHS, DH, HSZZDW, ZXZM, ZXZMCJYH, ZXDJ, YEAR_SJ, SUPPLIER_CODE, BID_PROJECT_CODE";


        //特殊的时间处理
        public static string FORMAT_DATE_TIMESTAMP = "to_timestamp('{0}','yyyy-mm-dd hh24:mi:ss')";

        //默认查询条件
        public static string DefaultCon = " AND PROJECT_NO ='{PROJECT_NO}'";

    }
}
